Facebook Data Source

Please enter the following parameters to connect to a Facebook data source:

Alias: name of the data source to be used in CData Virtuality Server
App Id and App Secret: the Facebook Application's identifier and secret that can be created on the developers page
Access Token: a key used to authenticate the application. It is provided by the Facebook API with the App ID after a web authorization. Then it is valid for 60 days since the last usage.
Data source parameters: additional connection parameters
Translator parameters: additional translator parameters.

The steps to create a Facebook App:

Login to the Facebook account you want to use.
Go to https://developers.facebook.com/
In order to be able to use the Facebook API with the CData Virtuality Facebook connector, you need to register your account as a developer (may be with the Facebook account that you already have), so if you haven't done already please proceed as follows:
1. Start with the registration as a developer with the existing Facebook account (if not you will have to create one) by choosing the Register button on the right top corner as shown below:
2. Accept the Platform Policy by toggling the switch to Yes.
3. Enter a valid phone number to receive a confirmation code and provide the same in confirmation Code text box and finish Registration by selecting Register.
4. Finally you should see a message like
Create a Facebook app with the following steps:
1. Choose the Create App option in the right top corner.
2. Enter a display name, contact email and a category and hit "Create App ID".
3. You will be prompted with the Security check questions something like is shown below and submit the correct answer.
4. In the last step, you will be prompted with the Product Setup. In this, you have to choose at least Facebook Login and say Get started.
5. You should see now something like this:
Change the settings:
1. Go to Settings -> Advanced and enable "Native or desktop app?"
2. There you can also enter your "Authorized Ad Account IDs" in "Advertising Accounts"
3. Go to Facebook -> Settings and enable "Embedded Browser OAuth Login".
Save the changes and switch back to the "Basic" to find the app ID and app secret (you may be asked for your password, if you unlock the app secret, when you click "show" )

Below are some examples of the most common data source parameters, see the reference manual for the full list:

importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates
importer.importProcedures=TRUE - stored procedures will be imported
importer.useProcedureSpecificName=TRUE - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

To fetch the Access token press the Fetch Access token button.